Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_14

R_14

Kinship

Kinship

Kin_KinshipID

 

 

R_25

R_25

Person

Person

Per_PersonID

 

 

R_124

R_124

IDCardType

Person

IdentityCardTypeID

 

 

R_125

R_125

IDCardType

IDCardTypeText

IdentityCardTypeID

 

 

R_126

R_126

Language

IDCardTypeText

LanguageID

 

 

R_362

R_362

Person

LPersonPerson

Per_PersonID

 

 

R_363

R_363

Person

LPersonPerson

PersonID

 

 

R_364

R_364

Kinship

LPersonPerson

KinshipID

 

 

R_429

R_429

Address

LPersonAddress

AddressID

 

 

R_430

R_430

Person

LPersonAddress

PersonID

 

 

R_431

R_431

AddressType

Address

AddressTypeID

 

 

R_438

R_438

Language

KinshipText

LanguageID

 

 

R_515

R_515

Kinship

KinshipText

KinshipID

 

 

R_561

R_561

Language

MaritalStatusText

LanguageID

 

 

R_594

R_594

MaritalStatus

MaritalStatusText

MaritalStatusID

 

 

R_621

R_621

Language

EducationText

LanguageID

 

 

R_622

R_622

Education

EducationText

EducationID

 

 

R_658

R_658

ActionType

Action

ActionTypeID

 

 

R_789

R_789

MaritalStatus

Person

MaritalStatusID

 

 

R_790

R_790

Education

Person

EducationID

 

 

R_903

R_903

Language

SexText

LanguageID

 

 

R_904

R_904

Sex

SexText

Sex

 

 

R_905

R_905

Sex

Person

Sex

 

 

R_1140

R_1140

Person

LPersonLanguage

PersonID

 

 

R_1141

R_1141

Language

LPersonLanguage

LanguageID

 

 

R_1142

R_1142

LanguageKnowledge

LPersonLanguage

LanguageKnowledgeID

 

 

R_1143

R_1143

LanguageKnowledge

LanguageKnowledgeText

LanguageKnowledgeID

 

 

R_1176

R_1176

Language

LanguageKnowledgeText

LanguageID

 

 

R_1364

R_1364

Language

CareTakerAuthorizationText

LanguageID

 

 

R_1365

R_1365

CareTakerAuthorization

CareTakerAuthorizationText

CaretakerAuthorizationID

 

 

R_1366

R_1366

CareTakerAuthorization

LPersonPerson

CaretakerAuthorizationID

 

 

R_2080

R_2080

Race

RaceText

RaceID

 

 

R_2081

R_2081

Race

Person

RaceID

 

 

R_8240

R_8240

Citizenship

CitizenshipText

CitizenshipID

 

 

R_8241

R_8241

Citizenship

Person

CitizenshipID

 

 

R_8550

R_8550

LPersonPerson

PersonInfoAuthorization

LPersonPersonID

 

 

R_8551

R_8551

CareTakerAuthorization

PersonInfoAuthorization

CaretakerAuthorizationID

 

 

R_8552

R_8552

Person

PersonInfoAuthorization

InsertingPersonID

 

 

R_8553

R_8553

Person

PersonInfoAuthorization

LastModifiedPersonID

 

 

R_8558

R_8558

Event

EventInfoPerson

EventID

 

 

R_8559

R_8559

Person

EventInfoPerson

PersonID

 

 

R_8560

R_8560

Person

EventInfoPerson

Per_PersonID2

 

 

R_8561

R_8561

Person

EventInfoPerson

Per_PersonID

 

 

R_8562

R_8562

CareTakerAuthorization

EventInfoPerson

CaretakerAuthorizationID

 

 

R_8567

R_8567

Event

PersonHospInformed

EventID

 

 

R_8568

R_8568

Person

PersonHospInformed

PersonID

 

 

R_8569

R_8569

Person

PersonHospInformed

Per_PersonID

 

 

R_8865

R_8865

Person

PersonInfoAuthorization

PersonID

 

 

R_9101

R_9101

EportalCareTakerPerm

EportalCareTakerPermText

EportalCareTakerPermId

 

 

R_9102

R_9102

EportalCareTakerPerm

CareTakerAuthorization

EportalCareTakerPermId

 

 


2